Can someone please help convert this one line of code from Formula to Lotus Script?

Notes/Domino 8 Forum

Subject: Can someone please help convert this one line of code from Formula to Lotus Script?

Feedback Type: Question

Product Area: Designer Client

Technical Area: Application development

Platform: Windows XP client

Release: All

Reproducible: Always

I used to use this piece of code to perform a lookup which worked flawlessly when I used it in the Formula language. However, our code has moved to Lotus Script and this line of code in the Lotus Script isn't working correctly.

MailQuotaFormula = Evaluate (|@DbLookup("":""; @Subset(@DbName;1) : "names.nsf"; "($MailFileQuotaView)"; @Name([CN]; @V3UserName) ; 2)|)
MailQuotaResults = MailQuotaFormula(0)

I had declared MailQuotaFormula as a Variant and MailQuotaResults as a String. The code works great for a short while (say, a week) and then all of a sudden one more users get an error "Variant does not contain a container". Since I couldn't get the error to go away, I just pulled the code from the templates to stop performing the lookups.

So basically, its just a simple lookup in the Domino Directory, in the ($MailFileQuotaView) view, search for a name and give me the value next to it. There surely has to be a more reliable way to do this and I'd be very grateful if someone could take just one moment to help me out.

Feedback number WEBB7V5JB4 created by ~George Fezkroplopikle on 08/21/2009

Status: Open
Comments: